# Using Microsoft SQL Server as a target

This section describes how to set up and use a Microsoft SQL Server database as a target in a replication task.

Information note

When configuring a task with a Microsoft SQL Server target endpoint, note the following:

* If the [Apply Changes](https://help.qlik.com/en-US/replicate/May2026/Content/Global_Common/Content/SharedEMReplicate/Design%20Tasks/tasks_setup.htm#Apply_changes) task option is enabled and the change processing mode is set to [Batch optimized apply](https://help.qlik.com/en-US/replicate/May2026/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_applychangtunestab.htm), it is recommended to enable the Apply batched changes to multiple tables concurrently option in the [Change Processing Tuning](https://help.qlik.com/en-US/replicate/May2026/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_applychangtunestab.htm) tab.

* When the Apply batched changes to multiple tables concurrently option is selected, the option to set a Global Error Handling policy will not be available. Also, some of the task-specific error handling defaults will be different.

  For more information, see the Apply batched changes to multiple tables concurrently option in the [Change Processing Tuning](https://help.qlik.com/en-US/replicate/May2026/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_applychangtunestab.htm) tab.

In this section:

* [Supported editions](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/SQL%20Server/Supported_editions.htm)
* [Prerequisites](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/SQL%20Server/prereqs_sql_server_target.htm)
* [Limitation and considerations](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/SQL%20Server/limitations_SQLServerDB.htm#ar_sqlserverds_1727505754_1655850)
* [Permissions](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/SQL%20Server/SQLServerDBTarget_Security.htm#ar_sqlserverds_1727505754_1643383)
* [Microsoft SQL Server target data types](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/SQL%20Server/SQLServerDB_target_DataTypes.htm#ar_sqlserverds_1727505754_1643423)
* [Setting general connection properties](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/SQL%20Server/SQLServerDB_DiaBox_target.htm#ar_sqlserverds_1727505754_1644159)
* [Setting advanced connection properties](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/SQL%20Server/SQLServerDBTarget_AdvProps.htm#ar_sqlserverds_1727505754_1644560)